Uganda Certificate of Education
COMPUTER STUDIES PRACTICAL
Paper 2
2 hours 15 minutes

INSTRUCTIONS TO CANDIDATES:
This paper consists of two sections, A, and B.
Section A contains one compulsory question. 
Section B contains three questions. Attempt any one question from this section.
Each candidate is provided with a new a blank compact disc-rewritable
Each candidate must produce a hard copy for each of their work to accompany the diskette or compact disc.
Self help wizards must not be used.

Turn Over

© 2020 ICT DEPARTMENT

SECTION A: (40 MARKS)
This section is compulsory.

1.	(a)   (i)    Using a word processor of your choice, typeset the following passage  
               as it is.                                                                                     (06 marks)

SAVOURY POTATO CAKES
Ingredients:
500g cooked and mashed potatoes
120g grated cheese
Salt and pepper
60g flour
Cooking oil
1 tablespoon Royco Mchuzi mix

               Mix the mashed potatoes well with the Royco, flour, salt and pepper
               Roll out onto a flour board and cut it into rounds using a biscuit cutter. Heat the oil in a frying pan and fry the cakes until golden brown.
               Remove from the fat and drain. Sprinkle cheese on top of each cake and put under grill until golden brown too.
               Serve hot. If you do not have a grill, put the cakes on a clean chopping board or metal tray. Put large, hot coals on a wire rack or mesh and hold it closely over the cakes until the cheese melts and turns golden brown.
               You can serve 6.
               [Adapted from Maria Murore-Daily Monitor Saturday May 5th 2007, 
               Page 11, Col 5.]
       (ii)    Apply a 6 point shadow text board around the typeset document. 
                                                                                                               (02 marks)
       (iii)  Bullet the list of the ingredients.                                              (01 mark)
       (iv)   Apply colour green on the heading, centre it and change front to 
               13.5”.                                                                                      (02 marks)
       (v)    Double space and justify and the body of the text.                (02 marks)
       (vi)   Set page margins to 1.8” left, 1.5” right 1.5” up and 1.6” bottom. 
                                                                                                               (02 marks)
       (vii)  Create one other page of the same page without retyping.     (01 mark)
       (viii) Number the pages in upper case alphabet.                            (02 marks)
       (ix)   Save your work in your name and index number.                  (01 mark)
       (x)    Print your work.                                                                       (01 mark)
(b)   The table below shows examination results of senior four students.
STUDENT’S NAME	CLASS	BOT
(X/10)	MID TERM
(X/20)	EOT
(X/70)	FINAL MARK	
Mugaga B.	S4B	06	14	41		
Matovu K.	S4A	07	17	49		
Bwavu S	S4C	05	10	35		
Ayub Irene	S4C	08	12	40		
Rehema Paul	S4B	04	15	44		
Allen Bob	S4A	08	16	48		
Alex T.	S4A	09	17	51		
Timothy K	S4B	08	18	55		
Nakonkona M.	S4C	06	16	50		

 NB: - BOT= Beginning of term mark and EOT = End of term mark
        - The final mark is a summation of BOT, MID-TERM and EOT.
(i)	Enter the students’ data above in a spreadsheet program.  
                                                                                          (06 marks)
(ii)	Determine the final score for every student by use of a form. 
                                                                                         (02 marks)
(iii)	At the end of the table in the empty row after Nakonkona M, insert a formula/function in the “FINAL MARK” column, to determine the best student.                                                                (03 marks)

(iv)	Insert a header “STUDENT PERFORMANCE” and center it. 
                                                                                          (02 marks)
(v)	Copy and paste your work to another worksheet.             (01 mark)
(vi)	Insert a blank row between Alex. T and Timothy K.         (01 mark)
(vii)	Plot a bar graph of the final mark against the student.     (03 marks)
(viii)	Save your work as your name and index number.             (01 mark)
(ix)	Print your work.                                                                  (01 mark)

Turn Over

SECTION B: (60 MARKS)
Answer any two questions from this section.
2.	The table below shows food items purchased at Kirinya S.S.S. create a database to manage Kirinya Food Supply.
ID	NAME	FOOD ITEM	CONTACTS	QUANTITY
IN STOCK	UNIT 
PRICE
(Shs)	TOTAL
COST	
U001	Okidi 	Matooke 	0772-459890	03	7,000		
U002	Jemba 	Lumonde 	0772-999999	02	15,000		
U003	Kizimula 	Flour 	0752-928012	05	200,000		
U004	Mukiibi 	Beans 	0712-606063	05	120,000		
U005	Mukalazi 	G.nuts 	0782-777770	03	180,000		
U006	Owinyi 	Oil 	0712-404440	05	40,000		
U007	Dembe 	Peas 	0411-000020	03	40,000		
U008	Mukankunsi 	Rice 	0412-282780	02	70,000		
U009	Mugenyi 	Soya	0782-215964	01	50,000		
U010	Mukyala 	Sim-Sim	0752-215946	03	80,000		

(a)	Create the table above, enter the data and name it Kirinya S.S. 
                                                                                                    (10 marks)
(b)	Make a form showing ID, name, quantity in stock, Unit price and it “Suppliers Form”                                                                        (06 marks)

(c)	Use the form to compute each of supplier’s total cost.               (03 marks)

(d)	Design a query to filter suppliers whose contacts begin with “077” and “078”. Name it “Suppliers’ query I.”                                          (06 marks)

(e)	Design another query to extract food items whose unit price is above Shs120,000 and save it as “Suppliers query II.”                         (05 marks)

3.	(a)      Assuming that you are standing for the post of headboy/headgirl, make a 
          four-slide presentation with relevant data about the major areas you 
          would focus on while campaigning.                                            (16 marks)
(b)   In addition, show the following on all your slides.
(i)	Uniform and pleasant text colours                                    (02 marks)
(ii)	Different text styles and sizes for different slides.            (02 marks)
(iii)	Footer as your name and index number on all sides.        (02 marks)
(iv)	Header as “ECHART OYEE” on all slides.                     (02 marks)
(v)	Clip art .                                                                            (02 marks)
(vi)	Automated animations and transition schemes.                 (01 mark)
(c)      Save your presentation using your index number.                       (01 mark)
(d)      Print your work.                                                                         (02 marks)

4.	(a)      Using a web publishing application, publish a website for your district                  
          with the following pages.
-	Homepage.                                                                           (05 marks)
-	District administration page                                                (04 marks)
-	Education page giving schools in the district.                     (04 marks)
-	Economic activities page for economic activities like farming, fishing, manufacturing, trade, etc.                                       (04 marks)
-	Social activities page for leisure activities, family life in the district, religion etc.                                                                         (04 marks)
-	District problems page to cater for things like, deforestation, food shortage, pests, diseases etc.                                               (04 marks)
NOTE:
You are expected to include the following on all your pages:
(i)	Relevant graphics.
(ii)	Appropriate background, font sizes and colour.
(iii)	Attractive layout
(b)     (i)       Insert your email address (mail to hyperlink) on the homepage. 
                                                                                                               (02 marks)

END

          (ii)      Save your website using your name.                                 (01 mark)
          (iii)     Print your work.                                                                (02 marks)